package com.ws.ssmzongjie3.mapper;

import com.ws.ssmzongjie3.bean.Carousel;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface CarouselMapper {
    @Insert("insert into carousel(carousel_title,picture_address,carousel_order,associated_lines,create_time) values(#{carousel_title},#{picture_address},#{carousel_order},#{associated_lines},now())")
    public int insertCarousel(Carousel carousel);
    @Delete("delete from carousel where carousel_id=#{carousel_id}")
    public int deleteCarousel(Carousel carousel);
    @Select("select * from carousel where carousel_id=#{carousel_id}")
    public Carousel getCarouselById(Carousel carousel);
    public void updateCarousel(Carousel carousel);
    public List<Carousel> listCarousel(Carousel carousel);
    public List<Carousel> listCarouselWithRoute (Carousel carousel);
}
